package com.qf.oa_system.mapper;

import com.qf.oa_system.entity.StudentsAndClasses;
import com.qf.oa_system.entity.StudentsAndLeaves;
import com.qf.oa_system.entity.StudentsSS;
import com.qf.oa_system.entity.WeeklyStudents;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface HeadStudentMapper {
    //联合查询
    List<StudentsAndClasses> queryStudentByTab();

    //请假申请的查询leaveTab为2的时候可看
    List<StudentsAndLeaves> queryLeavesByTab(int leaveTab);

    //同意申请
    int success(int leaveId);

    //导出学生信息表
    StudentsAndClasses queryStudentByStuId(int stuId);

    //导入学生信息表
    int insertStudentsByExcel(StudentsAndClasses studentsAndClasses);

    //班主任查询周报管理
    List<WeeklyStudents> queryWeeklyStudents();

    //查找学生的成绩
    StudentsSS queryStudentsSS(int sId);
}
